package com.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.Course;
import com.example.vo.CourseVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CourseMapper extends BaseMapper<Course> {
    @Select("select tc.id,tu.unit_name,tm.major_name,tc.create_time from tb_course tc join tb_unit tu on tc.unit_id=tu.id join tb_major tm on tc.major_id=tm.id")
    List<CourseVO> selectevo();
}
